use "C:\Users\bobby\Desktop\National Elections Only1.dta" 

*Set Temporal Aspects of Model
tsset location_id year, yearly

*Hindi-English Regressions (Overall and Religious Killing DVs)


*Model 1: National Elections (Overall)
eststo: xtpcse event_count Vote_Share_Nat State_Top_Nat A3party_Nat Independent_Nat Turnout_Nat Population Caste_Tribe Hindu Muslim Christian Sikkh Buddhist Jain Minority_Rel Riots, corr (psar1)
esttab using "C:\Users\brathwa1\Desktop\table4.rtf", replace se star(* 0.10 ** 0.05 *** 0.01) b(3) obslast brackets r2

*Model 2: National Elections (Religious Kill DV)
eststo: xtpcse Worst_Only Vote_Share_Nat State_Top_Nat A3party_Nat Independent_Nat Turnout_Nat Population Caste_Tribe Hindu Muslim Christian Sikkh Buddhist Jain Minority_Rel Riots, corr (psar1)
esttab using "C:\Users\brathwa1\Desktop\table4.rtf", append se star(* 0.10 ** 0.05 *** 0.01) b(3) obslast brackets r2


*Set up for Hindi Language Analysis
clear
use "C:\Users\bobby\Desktop\Hindi_English_Data_APSA.dta" 

*Set Temporal Aspects of Model
tsset location_id year, yearly

*Model 3: National Elections
eststo: xtpcse event_count Vote_Share_Nat State_Top_Nat A3party_Nat Independent_Nat Turnout_Nat Population Caste_Tribe Hindu Muslim Christian Sikkh Buddhist Jain Minority_Rel Riots, corr (psar1)
esttab using "C:\Users\brathwa1\Desktop\table4.rtf", append se star(* 0.10 ** 0.05 *** 0.01) b(3) obslast brackets r2

*Model 4: National Elections (with killing DV)
eststo: xtpcse Worst_Only Vote_Share_Nat State_Top_Nat A3party_Nat Independent_Nat Turnout_Nat Population Caste_Tribe Hindu Muslim Christian Sikkh Buddhist Jain Minority_Rel Riots, corr (psar1)
esttab using "C:\Users\brathwa1\Desktop\table4.rtf", append se star(* 0.10 ** 0.05 *** 0.01) b(3) obslast brackets r2


*Regression Results for Religious Violence Dimensions (English)

*Set-Up for Table 3 
clear
eststo clear
use "C:\Users\bobby\Desktop\National Elections Only1.dta"  
tsset location_id year, yearly

*Model 1: National Elections (Physical Violence DV)
eststo: xtpcse Physical Vote_Share_Nat State_Top_Nat A3party_Nat Independent_Nat Turnout_Nat Population Caste_Tribe Hindu Muslim Christian Sikkh Buddhist Jain Minority_Rel Riots, corr (psar1)
esttab using "C:\Users\brathwa1\Desktop\table5.rtf", replace se star(* 0.10 ** 0.05 *** 0.01) b(3) obslast brackets r2

*Model 2: National Elections (Sexual Violence DV)
eststo: xtpcse Sexual Vote_Share_Nat State_Top_Nat A3party_Nat Independent_Nat Turnout_Nat Population Caste_Tribe Hindu Muslim Christian Sikkh Buddhist Jain Minority_Rel Riots, corr (psar1)
esttab using "C:\Users\brathwa1\Desktop\table5.rtf", append se star(* 0.10 ** 0.05 *** 0.01) b(3) obslast brackets r2

*Model 3: National Elections (Property Violence DV)
eststo: xtpcse Property Vote_Share_Nat State_Top_Nat A3party_Nat Independent_Nat Turnout_Nat Population Caste_Tribe Hindu Muslim Christian Sikkh Buddhist Jain Minority_Rel Riots, corr (psar1)
esttab using "C:\Users\brathwa1\Desktop\table5.rtf", append se star(* 0.10 ** 0.05 *** 0.01) b(3) obslast brackets r2

*Model 4: National Elections (Dignity Violence DV)
eststo: xtpcse Dignity Vote_Share_Nat State_Top_Nat A3party_Nat Independent_Nat Turnout_Nat Population Caste_Tribe Hindu Muslim Christian Sikkh Buddhist Jain Minority_Rel Riots, corr (psar1)
esttab using "C:\Users\brathwa1\Desktop\table5.rtf", append se star(* 0.10 ** 0.05 *** 0.01) b(3) obslast brackets r2


*Regression Results for Religious Violence Dimensions (Hindi)

*Set-Up for Table 4 
clear
eststo clear
use "C:\Users\bobby\Desktop\Hindi_English_Data_APSA.dta" 
tsset location_id year, yearly

*Model 5: National Elections (Physical Violence Hindi DV)
eststo: xtpcse Physical Vote_Share_Nat State_Top_Nat A3party_Nat Independent_Nat Turnout_Nat Population Caste_Tribe Hindu Muslim Christian Sikkh Buddhist Jain Minority_Rel Riots, corr (psar1)
esttab using "C:\Users\brathwa1\Desktop\table6.rtf", replace se star(* 0.10 ** 0.05 *** 0.01) b(3) obslast brackets r2

*Model 6: National Elections (Sexual Violence Hindi DV)
eststo: xtpcse Sexual Vote_Share_Nat State_Top_Nat A3party_Nat Independent_Nat Turnout_Nat Population Caste_Tribe Hindu Muslim Christian Sikkh Buddhist Jain Minority_Rel Riots, corr (psar1)
esttab using "C:\Users\brathwa1\Desktop\table6.rtf", append se star(* 0.10 ** 0.05 *** 0.01) b(3) obslast brackets r2

*Model 7: National Elections (Property Violence Hindi DV)
eststo: xtpcse Property Vote_Share_Nat State_Top_Nat A3party_Nat Independent_Nat Turnout_Nat Population Caste_Tribe Hindu Muslim Christian Sikkh Buddhist Jain Minority_Rel Riots, corr (psar1)
esttab using "C:\Users\brathwa1\Desktop\table6.rtf", append se star(* 0.10 ** 0.05 *** 0.01) b(3) obslast brackets r2

*Model 8: National Elections (Dignity Violence Hindi DV)
eststo: xtpcse Dignity Vote_Share_Nat State_Top_Nat A3party_Nat Independent_Nat Turnout_Nat Population Caste_Tribe Hindu Muslim Christian Sikkh Buddhist Jain Minority_Rel Riots, corr (psar1)
esttab using "C:\Users\brathwa1\Desktop\table6.rtf", append se star(* 0.10 ** 0.05 *** 0.01) b(3) obslast brackets r2


*Set-up for Table 5 (Germany Models)
clear
eststo clear
use "C:\Users\bobby\Desktop\German_Combined_Data.dta"  

*Set Temporal Aspects of Model
tsset Country_ID Year, yearly

*1st Choice Voting
*Model 1: All Events
eststo: xtpcse Total_Event _1st_Vote Turnout _3_parties Independent population Christian Recent_Migrant Foreign, corr (psar1)
esttab using "C:\Users\brathwa1\Desktop\table1.csv", replace se star(* 0.10 ** 0.05 *** 0.01) b(3) obslast brackets r2

*Model 2: Killings Only
eststo: xtpcse worst _1st_Vote Turnout _3_parties Independent population Christian Recent_Migrant Foreign, corr (psar1)
esttab using "C:\Users\brathwa1\Desktop\table1.csv", replace se star(* 0.10 ** 0.05 *** 0.01) b(3) obslast brackets r2

*Model 3: Physical Dimension
eststo: xtpcse physical _1st_Vote Turnout _3_parties Independent population Christian Recent_Migrant Foreign, corr (psar1)
esttab using "C:\Users\brathwa1\Desktop\table1.csv", replace se star(* 0.10 ** 0.05 *** 0.01) b(3) obslast brackets r2

*Model 4: Property Dimension
eststo: xtpcse property _1st_Vote Turnout _3_parties Independent population Christian Recent_Migrant Foreign, corr (psar1)
esttab using "C:\Users\brathwa1\Desktop\table1.csv", replace se star(* 0.10 ** 0.05 *** 0.01) b(3) obslast brackets r2

*Model 5: Dignity Dimension
eststo: xtpcse dignity _1st_Vote Turnout _3_parties Independent population Christian Recent_Migrant Foreign, corr (psar1)
esttab using "C:\Users\brathwa1\Desktop\table1.csv", replace se star(* 0.10 ** 0.05 *** 0.01) b(3) obslast brackets r2


*Set up for Table 6 (France Models)
clear
eststo clear
use "C:\Users\bobby\Desktop\French_Combined_Data.dta" 

*Set Temporal Aspects of Model
tsset Country_ID Year, yearly

*Legislative Elections (1st Round)
*Model 1: All Events
eststo: xtpcse Total_Event Legislative_1 Turnout_L1 _3_parties_L Independent_L population Overseas, corr (psar1) 
esttab using "C:\Users\brathwa1\Desktop\table4.csv", replace se star(* 0.10 ** 0.05 *** 0.01) b(3) obslast brackets r2

*Model 2: Killings Only
eststo: xtpcse worst_counter Legislative_1 Turnout_L1 _3_parties_L Independent_L population Overseas, corr (psar1) 
esttab using "C:\Users\brathwa1\Desktop\table4.csv", replace se star(* 0.10 ** 0.05 *** 0.01) b(3) obslast brackets r2

*Model 3: Physical Dimension
eststo: xtpcse physical Legislative_1 Turnout_L1 _3_parties_L Independent_L population Overseas, corr (psar1) 
esttab using "C:\Users\brathwa1\Desktop\table4.csv", replace se star(* 0.10 ** 0.05 *** 0.01) b(3) obslast brackets r2

*Model 4: Sexual Dimension
eststo: xtpcse sexual Legislative_1 Turnout_L1 _3_parties_L Independent_L population Overseas, corr (psar1) 
esttab using "C:\Users\brathwa1\Desktop\table4.csv", replace se star(* 0.10 ** 0.05 *** 0.01) b(3) obslast brackets r2

*Model 5: Property Dimension
eststo: xtpcse property Legislative_1 Turnout_L1 _3_parties_L Independent_L population Overseas, corr (psar1) 
esttab using "C:\Users\brathwa1\Desktop\table4.csv", replace se star(* 0.10 ** 0.05 *** 0.01) b(3) obslast brackets r2

*Model 6: Dignity Dimension
eststo: xtpcse dignity Legislative_1 Turnout_L1 _3_parties_L Independent_L population Overseas, corr (psar1) 
esttab using "C:\Users\brathwa1\Desktop\table4.csv", replace se star(* 0.10 ** 0.05 *** 0.01) b(3) obslast brackets r2


